﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CMD_WEB.DAL;
using CMD.BAL.MISC;

namespace CMD.BAL.SOL
{
    public class Reportes
    {

        public DataTable GetDataReport(String FechaIni,String FechaFin,String NombreCliente)
        {
           
            DataTable solicitudes = new DataTable();
            //string query = "Exec SP_CMD_REPORTE '" + Convert.ToDateTime(FechaIni) + "','" + Convert.ToDateTime(FechaFin) + "','" + NombreCliente + "'" ;
            string query = "Exec SP_CMD_REPORTE '" + Utilities.NowWithENFormat(FechaIni) + "','" + Utilities.NowWithENFormat(FechaFin) + "','" + NombreCliente + "'" ;

            try
            {
                solicitudes = SrvDB.ExecuteQuery(query);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return solicitudes;

        }

    }
}
